DELETE FROM dbo.[CSK_Promo_Product_Promo_Map]
GO
DELETE FROM dbo.[CSK_Store_Product_Category_Map]
GO
DELETE FROM dbo.[CSK_Promo_Product_CrossSell_Map]
GO
DELETE FROM dbo.[CSK_Content_Text]
GO
DELETE FROM dbo.[CSK_Promo]
GO
DELETE FROM dbo.[CSK_Promo_Campaign]
GO
DELETE FROM dbo.[CSK_Promo_Bundle]
GO
DELETE FROM dbo.[CSK_Store_Ad]
GO
DELETE FROM dbo.[CSK_Store_AttributeTemplate]
GO
DELETE FROM dbo.[CSK_Store_Category]
GO
DELETE FROM dbo.[CSK_Store_Image]
GO
DELETE FROM dbo.[CSK_Store_ProductDescriptor]
GO
DELETE FROM dbo.[CSK_Store_Product]
GO
DELETE FROM dbo.[CSK_Store_Manufacturer]
GO
DELETE FROM dbo.[CSK_Tax_Rate]
GO

SET IDENTITY_INSERT dbo.[CSK_Store_Manufacturer] ON
PRINT 'Begin inserting data in CSK_Store_Manufacturer'
INSERT INTO  dbo.[CSK_Store_Manufacturer] ([manufacturerID],[manufacturer],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Tutto Bene',getdate(), 'c4uinstaller',getdate(), 'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Manufacturer] ([manufacturerID],[manufacturer],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Planet Umbraco',getdate(), 'c4uinstaller',getdate(), 'c4uinstaller')
SET IDENTITY_INSERT dbo.[CSK_Store_Manufacturer] OFF
PRINT 'Finished inserting data in CSK_Store_Manufacturer'
GO

SET IDENTITY_INSERT dbo.[CSK_Store_Category] ON
PRINT 'Begin inserting data in CSK_Store_Category'
INSERT INTO dbo.[CSK_Store_Category] ([categoryID],[categoryGUID],[categoryName],[imageFile],[parentID],[shortDescription],[longDescription],[listOrder],[manufacturerID],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (1,'8BFDB44B-4B24-4FC5-8356-42214DFB26C8','Caffe','',0,'','',1,1,getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO dbo.[CSK_Store_Category] ([categoryID],[categoryGUID],[categoryName],[imageFile],[parentID],[shortDescription],[longDescription],[listOrder],[manufacturerID],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (2,'8BFDB44B-4B24-4FC5-8356-42214DFB26C8','Grappa','',0,'','',1,1,getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO dbo.[CSK_Store_Category] ([categoryID],[categoryGUID],[categoryName],[imageFile],[parentID],[shortDescription],[longDescription],[listOrder],[manufacturerID],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (3,'8BFDB44B-4B24-4FC5-8356-42214DFB26C8','Workflow','',0,'','',1,2,getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO dbo.[CSK_Store_Category] ([categoryID],[categoryGUID],[categoryName],[imageFile],[parentID],[shortDescription],[longDescription],[listOrder],[manufacturerID],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (4,'8BFDB44B-4B24-4FC5-8356-42214DFB26C8','Social Media','',0,'','',1,2,getdate(),'c4uinstaller',getdate(),'c4uinstaller')
SET IDENTITY_INSERT dbo.[CSK_Store_Category] OFF
PRINT 'Finished inserting data in CSK_Store_Category'
GO


SET IDENTITY_INSERT dbo.[CSK_Store_Product] ON
PRINT 'Begin inserting data in CSK_Store_Product'
INSERT INTO dbo.[CSK_Store_Product] ([productID],[sku],[productGUID],[productName],[shortDescription],[manufacturerID],[attributeXML],[statusID],
[productTypeID],[shippingTypeID],[shipEstimateID],[taxTypeID],[stockLocation],[ourPrice],[retailPrice],[weight],[currencyCode],[unitOfMeasure],[adminComments],[length],[height],[width],[dimensionUnit],[isDeleted],[listOrder],[ratingSum],[totalRatingVotes],[defaultImage],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (1,'UGC','AACCAA0A-2009-4478-9EAC-B601A479244A','Un Gran Caffe'
,'The best coffee in the world!',1,'',2,5,1,3,3,'Shelf 12',12.5000,12.5000,1.0000,'USD','item','',5,5,10,'inches',0,2,4,1
,'/umbraco/commerce/images/products/caffe.jpg',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO dbo.[CSK_Store_Product] ([productID],[sku],[productGUID],[productName],[shortDescription],[manufacturerID],[attributeXML],[statusID],
[productTypeID],[shippingTypeID],[shipEstimateID],[taxTypeID],[stockLocation],[ourPrice],[retailPrice],[weight],[currencyCode],[unitOfMeasure],[adminComments],[length],[height],[width],[dimensionUnit],[isDeleted],[listOrder],[ratingSum],[totalRatingVotes],[defaultImage],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (2,'TBG','BA6E6B1F-03B9-43C0-B01F-C6C22A14060F','Grappa Grande'
,'The best grappa in the world!',1,'',2,5,1,3,3,'Shelf 13',65.5000,65.5000,1.0000,'USD','item','',5,5,10,'inches',0,2,4,1
,'/umbraco/commerce/images/products/grappa.jpg',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO dbo.[CSK_Store_Product] ([productID],[sku],[productGUID],[productName],[shortDescription],[manufacturerID],[attributeXML],[statusID],
[productTypeID],[shippingTypeID],[shipEstimateID],[taxTypeID],[stockLocation],[ourPrice],[retailPrice],[weight],[currencyCode],[unitOfMeasure],
[adminComments],[length],[height],[width],[dimensionUnit],[isDeleted],[listOrder],[ratingSum],[totalRatingVotes],[defaultImage],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (3,'UWW','00AAF97E-7397-483D-9BF3-04ED969EED04','Workflow Wonder'
,'The best workflow in the world!',2,'',2,1,3,1,3,'',99.0000,99.0000,1.0000,'USD','item','',0,0,0,'inches',0,2,4,1
,'/umbraco/commerce/images/products/workflow.jpg',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO dbo.[CSK_Store_Product] ([productID],[sku],[productGUID],[productName],[shortDescription],[manufacturerID],[attributeXML],[statusID],
[productTypeID],[shippingTypeID],[shipEstimateID],[taxTypeID],[stockLocation],[ourPrice],[retailPrice],[weight],[currencyCode],[unitOfMeasure],[adminComments],[length],[height],[width],[dimensionUnit],[isDeleted],[listOrder],[ratingSum],[totalRatingVotes],[defaultImage],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES (4,'USC','8341CC6F-3DCA-468D-9C8A-E24975F4322C','Umbraco Social Connector'
,'The best social connector in the world!',2,'',2,1,3,1,3,'',199.0000,199.0000,1.0000,'USD','item','',0,0,0,'inches',0,2,4,1
,'/umbraco/commerce/images/products/planetumbraco.png',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
SET IDENTITY_INSERT dbo.[CSK_Store_Product] OFF
PRINT 'Finished inserting data in CSK_Store_Product'
GO

SET IDENTITY_INSERT dbo.[CSK_Store_Image] ON
PRINT 'Begin inserting data in CSK_Store_Image'
INSERT INTO  dbo.[CSK_Store_Image] ([imageID],[productID],[imageFile],[listOrder],[caption],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(1, 1, '/umbraco/commerce/images/products/caffe.jpg', 0, 'Yum!',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Image] ([imageID],[productID],[imageFile],[listOrder],[caption],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(2, 2, '/umbraco/commerce/images/products/grappa.jpg', 0, 'Yum!',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Image] ([imageID],[productID],[imageFile],[listOrder],[caption],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(3, 3, '/umbraco/commerce/images/products/workflow.jpg', 1, '',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Image] ([imageID],[productID],[imageFile],[listOrder],[caption],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(4, 4, '/umbraco/commerce/images/products/planetumbraco.png', 0, '',getdate(),'c4uinstaller',getdate(),'c4uinstaller')
SET IDENTITY_INSERT dbo.[CSK_Store_Image] OFF
PRINT 'Finished inserting data in CSK_Store_Image'
GO

PRINT 'Begin inserting data in CSK_Store_Product_Category_Map'
INSERT INTO  dbo.[CSK_Store_Product_Category_Map] ([productID],[categoryID],[listOrder],[isFeatured],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(1, 1, 0, 0, getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Product_Category_Map] ([productID],[categoryID],[listOrder],[isFeatured],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(2, 2, 0, 0, getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Product_Category_Map] ([productID],[categoryID],[listOrder],[isFeatured],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(3, 3, 0, 0, getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Store_Product_Category_Map] ([productID],[categoryID],[listOrder],[isFeatured],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) 
VALUES(4, 4, 0, 0, getdate(),'c4uinstaller',getdate(),'c4uinstaller')
PRINT 'Finished inserting data in CSK_Store_Product_Category_Map'
GO

SET IDENTITY_INSERT dbo.[CSK_Tax_Rate] ON
PRINT 'Begin inserting data in CSK_Tax_Rate'
INSERT INTO  dbo.[CSK_Tax_Rate] ([rateID],[rate],[state],[zipCode],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 0.0825, 'CA', NULL, getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Tax_Rate] ([rateID],[rate],[state],[zipCode],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 0.0615, 'HI', NULL, getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Tax_Rate] ([rateID],[rate],[state],[zipCode],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 0.0230, 'AL', '', getdate(),'c4uinstaller',getdate(),'c4uinstaller')
INSERT INTO  dbo.[CSK_Tax_Rate] ([rateID],[rate],[state],[zipCode],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, 0.0230, 'AK', '', getdate(),'c4uinstaller',getdate(),'c4uinstaller')
SET IDENTITY_INSERT dbo.[CSK_Tax_Rate] OFF
PRINT 'Finished inserting data in CSK_Tax_Rate'
GO
